package model

import (
	"context"
	"fmt"
	"gorm.io/gorm"
	"time"
	"unlimited-comments/global"
)

type Comment struct {
	Id        uint32         `gorm:"column:id;type:int UNSIGNED;comment:评论id;primaryKey;not null;" gorm:"id" json:"id"`                                            // 评论id
	UserId    int32          `gorm:"column:user_id;type:int;comment:用户id;not null;" gorm:"user_id" json:"user_id"`                                                 // 用户id
	VideoId   int32          `gorm:"column:video_id;type:int;comment:视频id;not null;" gorm:"video_id" json:"video_id"`                                              // 视频id
	Content   string         `gorm:"column:content;type:varchar(300);comment:评论内容;not null;" gorm:"content" json:"content"`                                      // 评论内容
	CreatedAt time.Time      `gorm:"column:created_at;type:datetime(3);comment:发布时间;not null;default:CURRENT_TIMESTAMP(3);" gorm:"created_at" json:"created_at"` // 发布时间
	UpdatedAt time.Time      `gorm:"column:updated_at;type:datetime(3);comment:修改时间;not null;default:CURRENT_TIMESTAMP(3);" gorm:"updated_at" json:"updated_at"` // 修改时间
	DeletedAt gorm.DeletedAt `gorm:"column:deleted_at;type:datetime(3);comment:删除时间;default:NULL;" gorm:"deleted_at" json:"deleted_at"`                          // 删除时间
}

func (c *Comment) TableName() string {
	return "comment"
}

func (c *Comment) AddComment() error {
	return global.DB.Create(&c).Error
}

func (c *Comment) DeleteComment() error {
	return global.DB.Delete(&c).Error
}

func (c *Comment) ListComment() (comment []*Comment, err error) {
	err = global.DB.Find(&comment).Error
	global.RDB.Set(context.Background(), fmt.Sprintf("comment:%d", c.Id), comment, 0)
	return
}

func (c *Comment) ListByAuthorComment() (comment []*Comment, err error) {
	err = global.DB.Where("user_id = ?", c.UserId).Find(&comment).Error
	return
}
